CREATE procedure [dbo].[BAEGetCommittees] as
SELECT PROD_TYPE AS CommitteeType, PRODUCT_CODE AS committee_product_code, TITLE AS CommitteeName,
       DESCRIPTION AS CommitteeDescription
  FROM Product
    WHERE
        PROD_TYPE = 'COMMITTEE' AND WEB_OPTION = 1
    ORDER BY
        CommitteeType,
        CommitteeName,
        PRODUCT_CODE

GO